<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" pageEncoding="UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt" %>

<html>
<head>
    <title>登录页</title>
    <%--echart线图、柱状图、饼图等各种图型库 cdn--%>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts/dist/echarts.min.js"></script>
    <%--jquery cdn--%>
    <script type="text/javascript" src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.1/jquery.js"></script>
</head>
<body>

小组 <input name="group"><br>

<button onclick="zzt()"> 点击展示柱状图</button>
<button onclick="zxt()"> 点击展示折线图</button>
<button onclick="excel()"> 点击导出Excel</button>

<div id="main" style="height: 500px;width:  500px"></div>
</body>

<script>


    function excel() {
        let group = $('[name=group]').val();
        window.location.href='excel.do?group=' +group
    }

    function zxt() {
        let group = $('[name=group]').val();

        $.ajax({
            url:'zzt.do?group=' + group,
            success:function (data){
                console.log(data)

                var x = []
                var y = []

                for (let i = 0; i < data.length; i++) {
                    x.push(data[i].xdata)
                    y.push(data[i].ydata)
                }

                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    xAxis: {
                        type: 'category',
                        data: x
                    },
                    yAxis: {
                        type: 'value'
                    },
                    series: [
                        {
                            data: y,
                            type: 'line'
                        }
                    ]
                };

                option && myChart.setOption(option);


            }
        })

    }

    function zzt() {
        let group = $('[name=group]').val();

        $.ajax({
            url:'zzt.do?group=' + group,
            success:function (data){
                console.log(data)

                    var x = []
                    var y = []

                for (let i = 0; i < data.length; i++) {
                    x.push(data[i].xdata)
                    y.push(data[i].ydata)
                }
                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    xAxis: {
                        type: 'category',
                        data: x
                    },
                    yAxis: {
                        type: 'value'
                    },
                    series: [
                        {
                            data: y,
                            type: 'bar',
                            showBackground: true,
                            backgroundStyle: {
                                color: 'rgba(180, 180, 180, 0.2)'
                            }
                        }
                    ]
                };

                option && myChart.setOption(option);

            }
        })

    }
</script>
</html>